﻿CREATE TABLE [dbo].[RouteList] (
    [id] INT IDENTITY (1, 1) NOT NULL,
	[nomdog] NVARCHAR(MAX) NOT NULL,
	[datedoc] NVARCHAR(MAX) NOT NULL,
	[d_datedoc] NVARCHAR(MAX) NULL,
	[dt_datedoc] DATETIME NULL,
	[id_RouteTable] INT NULL,
	[departure] NVARCHAR(MAX) NULL,
	[arrive] NVARCHAR(MAX) NULL,
	[total_length] REAL NULL,
	[total_free_length] REAL NULL,
	[total_reis_plan] REAL NULL,
	[total_reis_fact] REAL NULL,
	[total_work_time] REAL NULL,
	[total_rest_time] REAL NULL,
	[sum_plan] REAL NULL,
	[sum_fact] REAL NULL,
	[total_workt_fact] REAL NULL,
	[total_restt_fact] REAL NULL,
	[id_driver] int NULL,
	[id_vehicle] int NULL,
	[id_mechanic] int NULL,
	[id_dispetcher] int NULL,
	[total_length_fact] REAL NULL,
	[total_free_fact] REAL NULL,
	[nomdeparture] INT NULL,
    PRIMARY KEY CLUSTERED ([id] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

